<?php

/************************************************************************/
/* PHP-NUKE: Web Portal System                                          */
/* ===========================                                          */
/*                                                                      */
/* Copyright (c) 2005 by Francisco Burzi                                */
/* http://phpnuke.org                                                   */
/*                                                                      */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License.       */
/************************************************************************/

if ( !defined('BLOCK_FILE') ) {
    Header("Location: ../index.php");
    die();
}

global $prefix, $db, $sitename, $subscription_url, $user, $cookie;

if (paid()) {
  cookiedecode($user);
  $sql = "SELECT * FROM ".$prefix."_subscriptions WHERE userid='".intval($cookie[0])."'";
  $query = $db->sql_query($sql);
  $row = $db->sql_fetchrow($query);
  if (!empty($subscription_url)) {
    $content = "<center>"._YOUARE." <a href='$subscription_url'>"._SUBSCRIBER."</a> "._OF." $sitename<br>";
  } else {
    $content = "<center>"._YOUARE." "._SUBSCRIBER." "._OF." $sitename<br>";
  }
  $diff = $row['subscription_expire']-time();
  $yearDiff = floor($diff/60/60/24/365);
  $diff -= $yearDiff*60*60*24*365;
  if ($yearDiff < 1) {
    $diff = $row['subscription_expire']-time();
  }
  $daysDiff = floor($diff/60/60/24);
  $diff -= $daysDiff*60*60*24;
  $hrsDiff = floor($diff/60/60);
  $diff -= $hrsDiff*60*60;
  $minsDiff = floor($diff/60);
  $diff -= $minsDiff*60;
  $secsDiff = $diff;
  if ($yearDiff < 1) {
    $rest = "$daysDiff "._SBDAYS."<br>$hrsDiff "._SBHOURS."<br>$minsDiff "._SBMINUTES."<br>$secsDiff "._SBSECONDS."";
  } elseif ($yearDiff == 1) {
    $rest = "$yearDiff "._SBYEAR."<br>$daysDiff "._SBDAYS."<br>$hrsDiff "._SBHOURS."<br>$minsDiff "._SBMINUTES."<br>$secsDiff "._SBSECONDS."";
  } elseif ($yearDiff > 1) {
    $rest = "$yearDiff "._SBYEARS."<br>$daysDiff "._SBDAYS."<br>$hrsDiff "._SBHOURS."<br>$minsDiff "._SBMINUTES."<br>$secsDiff "._SBSECONDS."";
  }
  $content .= "<br><b>"._SUBEXPIREIN."<br><br><font color='#FF0000'>$rest</font></b></center>";
} else {
  $content = "<center>"._NOTSUB." $sitename. "._SUBFROM." <a href='$subscription_url'>"._HERE."</a> "._NOW."";
}

?>